drop table if exists sys_user;

/*==============================================================*/
/* Table: sys_user                                              */
/*==============================================================*/
create table sys_user (
  id                   INT8                 not null,
  name                 VARCHAR(50)          null,
  age                  INT4                 null,
  type                 CHAR                 null,
  ctime                TIMESTAMP            null,
  constraint PK_SYS_USER primary key (id)
);

comment on table sys_user is
'用户测试';

comment on column sys_user.id is
'用户ID';

comment on column sys_user.name is
'用户名';

comment on column sys_user.age is
'用户年龄';

comment on column sys_user.type is
'0:禁用 1:正常';

comment on column sys_user.ctime is
'自定义填充的创建时间';

-- ----------------------------
--  Records of `sys_user`
-- ----------------------------
BEGIN;
INSERT INTO sys_user(id,name,age,ctime,type) VALUES (11, 'Tom', 23, current_timestamp, '1');
INSERT INTO sys_user(id,name,age,ctime,type) VALUES (12, 'Jammy', 24, current_timestamp, '1');
INSERT INTO sys_user(id,name,age,ctime,type) VALUES (13, 'Jess', 25, current_timestamp, '1');
INSERT INTO sys_user(id,name,age,ctime,type) VALUES (14, 'Toni', 26, current_timestamp, '1');
INSERT INTO sys_user(id,name,age,ctime,type) VALUES (15, 'Jom', 27, current_timestamp, '1');
INSERT INTO sys_user(id,name,age,ctime,type) VALUES (16, 'Blus', 28, current_timestamp, '1');
INSERT INTO sys_user(id,name,age,ctime,type) VALUES (17, 'Maz', 29, current_timestamp, '1');
INSERT INTO sys_user(id,name,age,ctime,type) VALUES (18, 'Hmeimei', 21, current_timestamp, '1');
INSERT INTO sys_user(id,name,age,ctime,type) VALUES (19, 'Lilei', 21, current_timestamp, '1');
INSERT INTO sys_user(id,name,age,ctime,type) VALUES (20, 'Home', 21, current_timestamp, '1');
INSERT INTO sys_user(id,name,age,ctime,type) VALUES (21, 'Hant', 21, current_timestamp, '1');
COMMIT;

